package tools;

import java.util.ArrayList;

import com.hibernate.model.Material;

public class TestList {
	public static void main(String[] args) {

		String[] abcSdtring = { "REPORT_ACCESS_PATH", "REPORT_ACCESS_PATH_CHICTALK       ",
				"REPORT_ACCESS_PATH_DEMO           ", "REPORT_AD_RESULT_AREA             ",
				"REPORT_AD_RESULT_BASE             ", "REPORT_AD_RESULT_HOUR             ",
				"REPORT_CATEGORY_AD                ", "REPORT_CATEGORY_ADSITE            ",
				"REPORT_CATEGORY_ADSITE_AGE        ", "REPORT_CATEGORY_ADSITE_ATTENTION  ",
				"REPORT_CATEGORY_ADSITE_BUY        ", "REPORT_CATEGORY_ADSITE_EDU        ",
				"REPORT_CATEGORY_ADSITE_IDENTITY   ", "REPORT_CATEGORY_ADSITE_INCOME     ",
				"REPORT_CATEGORY_ADSITE_SEX        ", "REPORT_CATEGORY_AD_TEMP           ",
				"REPORT_CATEGORY_AD_TEMP2          ", "REPORT_CATEGORY_DAY               ",
				"REPORT_CATEGORY_DAY_ALL           ", "REPORT_CATEGORY_LABEL_AGE         ",
				"REPORT_CATEGORY_LABEL_ATTENTION   ", "REPORT_CATEGORY_LABEL_BUY         ",
				"REPORT_CATEGORY_LABEL_EDU         ", "REPORT_CATEGORY_LABEL_IDENTITY    ",
				"REPORT_CATEGORY_LABEL_INCOME      ", "REPORT_CATEGORY_LABEL_SEX         ",
				"REPORT_CATEGORY_MATERIAL          ", "REPORT_CATEGORY_MATERIAL_AGE      ",
				"REPORT_CATEGORY_MATERIAL_ATTENTION", "REPORT_CATEGORY_MATERIAL_BUY      ",
				"REPORT_CATEGORY_MATERIAL_EDU      ", "REPORT_CATEGORY_MATERIAL_IDENTITY ",
				"REPORT_CATEGORY_MATERIAL_INCOME   ", "REPORT_CATEGORY_MATERIAL_SEX      ",
				"REPORT_CATEGORY_ORDER_AGE         ", "REPORT_CATEGORY_ORDER_ATTENTION   ",
				"REPORT_CATEGORY_ORDER_BUY         ", "REPORT_CATEGORY_ORDER_EDU         ",
				"REPORT_CATEGORY_ORDER_IDENTITY    ", "REPORT_CATEGORY_ORDER_INCOME      ",
				"REPORT_CATEGORY_ORDER_SEX         ", "REPORT_CATEGORY_OWNER_AGE         ",
				"REPORT_CATEGORY_OWNER_ATTENTION   ", "REPORT_CATEGORY_OWNER_BUY         ",
				"REPORT_CATEGORY_OWNER_EDU         ", "REPORT_CATEGORY_OWNER_IDENTITY    ",
				"REPORT_CATEGORY_OWNER_INCOME      ", "REPORT_CATEGORY_OWNER_SEX         ",
				"REPORT_CATEGORY_PLAN_AGE          ", "REPORT_CATEGORY_PLAN_ATTENTION    ",
				"REPORT_CATEGORY_PLAN_BUY          ", "REPORT_CATEGORY_PLAN_EDU          ",
				"REPORT_CATEGORY_PLAN_IDENTITY     ", "REPORT_CATEGORY_PLAN_INCOME       ",
				"REPORT_CATEGORY_PLAN_SEX          ", "REPORT_CATEGORY_WEBSITE_AGE       ",
				"REPORT_CATEGORY_WEBSITE_ATTENTION ", "REPORT_CATEGORY_WEBSITE_BUY       ",
				"REPORT_CATEGORY_WEBSITE_EDU       ", "REPORT_CATEGORY_WEBSITE_IDENTITY  ",
				"REPORT_CATEGORY_WEBSITE_INCOME    ", "REPORT_CATEGORY_WEBSITE_SEX       ",
				"REPORT_DAY                        ", "REPORT_DAY_AREA                   ",
				"REPORT_DAY_AREA_DSP_TEMP          ", "REPORT_DAY_AREA_RATIO             ",
				"REPORT_DAY_AREA_TEMP              ", "REPORT_DAY_AREA_TEMP2             ",
				"REPORT_DAY_AREA_TEST              ", "REPORT_DAY_AREA_TODAY             ",
				"REPORT_DAY_DSP_BASE               ", "REPORT_DAY_DSP_TEMP               ",
				"REPORT_DAY_HOUR                   ", "REPORT_DAY_HOUR_TEMP              ",
				"REPORT_DAY_HOUR_TEMP2             ", "REPORT_DAY_HOUR_TEST              ",
				"REPORT_DAY_HOUR_TODAY             ", "REPORT_DAY_TEMP                   ",
				"REPORT_DAY_TEMP2                  ", "REPORT_DAY_TEST                   ",
				"REPORT_EXIT_PAGE                  ", "REPORT_EXIT_PAGE_CHICTALK         ",
				"REPORT_EXIT_PAGE_DEMO             ", "REPORT_HOT_PAGE                   ",
				"REPORT_HOT_PAGE_CHICTALK          ", "REPORT_HOT_PAGE_DEMO              ",
				"REPORT_KEY_PAGE                   ", "REPORT_KEY_PAGE_ACCESS            ",
				"REPORT_ORDER_INFO                 ", "REPORT_PEOPLE_AREA                ",
				"REPORT_PEOPLE_INCOME              ", "REPORT_PEOPLE_INCOME_COLUMN       ",
				"REPORT_PEOPLE_PROPERTY            ", "REPORT_PEOPLE_PROPERTY_COLUMN     ",
				"REPORT_PEOPLE_SEX                 ", "REPORT_PEOPLE_SEX_COLUMN          ",
				"REPORT_TITLE                      ", "REPORT_TITLE_SYS                  ",
				"REPORT_URL_FROM                   ", "REPORT_URL_FROM_DEMO              ",
				"REPORT_WEBSITE                    ", "REPORT_WEBSITE_COLUMN" };

		int i = 1;
		for (String ab : abcSdtring) {
			ab = ab.replace(" ", "");
			System.out.print("DELETE FROM " + ab + " WHERE 1=1; ");
			if (i++ % 2 == 0) {
				System.out.println("\n\n");
			}
		}

	}

	public void abc() {
		ArrayList<Material> list = new ArrayList<Material>();
		for (int i = 0; i < 10; i++) {
			Material material = new Material();
			material.setId((long) i);
			material.setName("name" + i);
			list.add(material);
		}

		for (int i = 0; i < list.size(); i++) {
			Material material = list.get(i);
			if (material.getId() % 2 == 0) {
				list.remove(i);
			}
		}
		System.out.println(list.size());
		for (Material material : list) {
			System.out.println(material.getId() + ":::" + material.getName());
		}
		Integer aInteger = null;
		// aInteger = Integer.valueOf(null);
		System.out.println(aInteger);
		for (int i = 18357; i < 18369; i++) {
			System.out.print("(" + i + "),");
		}
	}
}
